Creating a SQL Server account for use by Meridian

Ideally, the SQL Server account used by Meridian should have the System Administrator server role. If your organization’s security policy prohibits this, you can create an account with the necessary permissions.

Before you begin

A custom SQL Server account for use by Meridian may only be created and assigned after the SQL Server database has been created by Meridian as described in Configuring the SQL Server account used by Meridian.

To create a SQL Server account for use by Meridian:

1. In SQL Server Enterprise Manager, create a new database user.
2. In the SQL Server Login Properties dialog, on the General page select SQL Server Authentication and the vault database as the default database from the Database list.
3. In the SQL Server Login Properties dialog, on the Database Access page select the vault database from the database list.
4. After the user and its login have been created, modify its properties and use one of the following methods to set the required permissions for the new account:

• Grant the user the db_owner database role for the database selected in step 2. This will allow this account to have all required permissions to work with this database, but not for any other one.
• Grant the user all permissions (SELECT, INSERT, UPDATE, DELETE, EXEC, and DRI) for all objects in the database except for the system objects (objects with names sys*).

After you implement one of these methods, the account will have all required privileges to access an existing vault database.

Note    If the account should also be used to create any new vault databases, grant the account the Database Creators server role (this role has the CREATE DATABASE, ALTER DATABASE, and RESTORE permissions).

5. Configure Meridian to use the new account name as described in Configuring the SQL Server account used by Meridian.